CREATE VIEW Name_All (
Activity_Fee, ADDRESS_NUM_1, ADDRESS_NUM_2, ADDRESS_NUM_3, Advertiser, Anniversary, Annual_Revenue, BACKORDERS, BAR_CODE, BILL_ADDRESS_NUM, BIRTH_DATE, Board, BT_ID, CATEGORY, CHAPTER, ChapterCode, Christmas_Appeal, CITY, CO_ID, CO_MEMBER_TYPE, COMPANY, COMPANY_RECORD, COMPANY_SORT, CONTACT_RANK, COUNTRY, COUNTY, CREDIT_LIMIT, CRRT, DATE_ADDED, Date_Certified, Date_Founded, Deliv_Pref, DESIGNATION, DISPLAY_CURRENCY, DUP_MATCH_KEY, Education_Level, EMAIL, EXCLUDE_DIRECTORY, EXCLUDE_MAIL, Exhibitor, FAX, FIRST_NAME, FR_12MoAmt, FR_1YearAgoAmt, FR_24MoAmt, FR_2YearAgoAmt, FR_36MoAmt, FR_3MoAmt, FULL_ADDRESS, FULL_NAME, FUNCTIONAL_TITLE, GENDER, HOME_PHONE, ID, INFORMAL, INTENT_TO_EDIT, Interest_Codes, JOIN_DATE, Join1, Join2, Join3, Key_Contact, LAST_FIRST, LAST_NAME, LAST_UPDATED, Legislative, List_Codes, MAIL_ADDRESS_NUM, MAIL_CODE, MAJOR_KEY, MEMBER_RECORD, MEMBER_STATUS, MEMBER_STATUS_DATE, MEMBER_TYPE, MIDDLE_NAME, Mobile_Phone, MT_CHANGE_DATE, Newsletter, NO_STATEMENTS, ORG_CODE, PAID_THRU, PREFIX, PREVIOUS_MT, RENEW_MONTHS, RENEWED_THRU, School_Attended, SHIP_ADDRESS_NUM, SIC_CODE, SOURCE_CODE, Sponsor, Spouse, Staff_Size, STATE_HOUSE, STATE_PROVINCE, STATE_SENATE, STATUS, Sub1, Sub2, SUFFIX, System_Type, TAX_AUTHOR_DEFAULT, TAX_EXEMPT, TERMS_CODE, TITLE, TOLL_FREE, UPDATED_BY, US_CONGRESS, USE_VAT_TAXATION, VAT_COUNTRY, VAT_REG_NUMBER, Web_Site, WEBSITE, WORK_PHONE, ZIP
) AS
SELECT Name_Demo.Activity_Fee, Name.ADDRESS_NUM_1, Name.ADDRESS_NUM_2, Name.ADDRESS_NUM_3, Name_Demo.Advertiser, Name_FRProfile.Anniversary, Organization_Demo.Annual_Revenue, Name_Fin.BACKORDERS, Name.BAR_CODE, Name.BILL_ADDRESS_NUM, Name.BIRTH_DATE, Name_Demo.Board, Name.BT_ID, Name.CATEGORY, Name.CHAPTER, Name_JoinOnline.ChapterCode, Name_FRProfile.Christmas_Appeal, Name.CITY, Name.CO_ID, Name.CO_MEMBER_TYPE, Name.COMPANY, Name.COMPANY_RECORD, Name.COMPANY_SORT, Name.CONTACT_RANK, Name.COUNTRY, Name.COUNTY, Name_Fin.CREDIT_LIMIT, Name.CRRT, Name.DATE_ADDED, Name_Demo.Date_Certified, Organization_Demo.Date_Founded, Name_FRProfile.Deliv_Pref, Name.DESIGNATION, Name.DISPLAY_CURRENCY, Name.DUP_MATCH_KEY, Name_FRProfile.Education_Level, Name.EMAIL, Name.EXCLUDE_DIRECTORY, Name.EXCLUDE_MAIL, Name_Demo.Exhibitor, Name.FAX, Name.FIRST_NAME, Name_FRProfile.FR_12MoAmt, Name_FRProfile.FR_1YearAgoAmt, Name_FRProfile.FR_24MoAmt, Name_FRProfile.FR_2YearAgoAmt, Name_FRProfile.FR_36MoAmt, Name_FRProfile.FR_3MoAmt, Name.FULL_ADDRESS, Name.FULL_NAME, Name.FUNCTIONAL_TITLE, Name.GENDER, Name.HOME_PHONE, Name.ID, Name.INFORMAL, Name.INTENT_TO_EDIT, Name_Demo.Interest_Codes, Name.JOIN_DATE, Name_JoinOnline.Join1, Name_JoinOnline.Join2, Name_JoinOnline.Join3, Name_Demo.Key_Contact, Name.LAST_FIRST, Name.LAST_NAME, Name.LAST_UPDATED, Name_Demo.Legislative, Name_Demo.List_Codes, Name.MAIL_ADDRESS_NUM, Name.MAIL_CODE, Name.MAJOR_KEY, Name.MEMBER_RECORD, Name.MEMBER_STATUS, Name.MEMBER_STATUS_DATE, Name.MEMBER_TYPE, Name.MIDDLE_NAME, Name_Demo.Mobile_Phone, Name.MT_CHANGE_DATE, Name_Demo.Newsletter, Name_Fin.NO_STATEMENTS, Name.ORG_CODE, Name.PAID_THRU, Name.PREFIX, Name.PREVIOUS_MT, Name_Fin.RENEW_MONTHS, Name_Fin.RENEWED_THRU, Name_Demo.School_Attended, Name.SHIP_ADDRESS_NUM, Name.SIC_CODE, Name.SOURCE_CODE, Name_Demo.Sponsor, Name_Demo.Spouse, Name_Demo.Staff_Size, Name.STATE_HOUSE, Name.STATE_PROVINCE, Name.STATE_SENATE, Name.STATUS, Name_JoinOnline.Sub1, Name_JoinOnline.Sub2, Name.SUFFIX, Name_Demo.System_Type, Name_Fin.TAX_AUTHOR_DEFAULT, Name_Fin.TAX_EXEMPT, Name_Fin.TERMS_CODE, Name.TITLE, Name.TOLL_FREE, Name.UPDATED_BY, Name.US_CONGRESS, Name_Fin.USE_VAT_TAXATION, Name_Fin.VAT_COUNTRY, Name_Fin.VAT_REG_NUMBER, Organization_Demo.Web_Site, Name.WEBSITE, Name.WORK_PHONE, Name.ZIP
  FROM Name, Name_Demo, Name_FRProfile, Name_JoinOnline, Organization_Demo, Name_Fin
where Name.ID = Name_Demo.ID and  Name.ID = Name_FRProfile.ID and  Name.ID = Name_JoinOnline.ID and  Name.ID = Organization_Demo.ID and Name.ID = Name_Fin.ID
GO
GRANT REFERENCES ON  [dbo].[Name_All] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_All] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_All] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_All] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_All] TO [IMIS]
GO